Download Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration.1z0-078.ExamTopics.2025-12-16.90q.vcex

Vendor: Oracle
Exam Code: 1z0-078
Exam Name: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Date: Dec 16, 2025
File Size: 756 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which three statements are true about Oracle 19c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)
  1. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.
  2. They can be policy managed.
  3. They can be administrator managed.
  4. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.
  5. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.
  6. They are automatically configured to use Enterprise Manager Express.
Correct answer: BCD
Question 2
Which three statements are true about opatch version 19? (Choose three.)
  1. It cannot run with root privileges on a UNIX-like system.
  2. It can only apply patches on the cluster node from where it is issued.
  3. It can apply patches to a database ORACLE_HOME.
  4. It can apply a patchset to a database ORACLE_HOME.
  5. It can apply some patches without shutting down database instances.
  6. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
Correct answer: CDE
Question 3
Examine this tnsnames entry from a RAC configuration using a SCAN listener:
Which two statements are true about clients using this entry to connect? (Choose two.)
  1. The host name in the tnsnames entry must be changed if nodes are added or removed from the cluster.
  2. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
  3. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
  4. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
  5. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.
Correct answer: CE
Question 4
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)
  1. A CR image may get served from one instance to another to satisfy a read request.
  2. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
  3. An XCUR image is not shipped to another instance until commits occur for updated rows on the block.
  4. A PI block image may exist for a specific database block in only one instance.
  5. An XCUR block image may exist for a specific database block in only one instance.
Correct answer: AE
Question 5
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
  1. An ADVM volume is individually named and can contain only one file system.
  2. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
  3. File systems contained in ADVM volumes may only contain database files.
  4. Only one ADVM volume can be created in an ASM disk group.
  5. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
Correct answer: AB
Question 6
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
  1. HANFS provides high availability in case of an NFS client failure.
  2. HANFS' performance depends on the characteristics of the underlying ASM disks.
  3. HANFS does not depend on NFS services provided by the underlying operating system.
  4. HANFS provides high availability in case of cluster node failure.
  5. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.
Correct answer: BD
Question 7
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
  1. They listen only for database instances on the same node.
  2. They listen on behalf of any ASM instance and all database instances on the same node.
  3. They listen only for the ASM instance on the same node.
  4. There can be only one node listener per node.
  5. They run from the Grid Infrastructure home by default.
Correct answer: BE
Question 8
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
  1. Each cluster node must have at least two network interface cards.
  2. You must enable the Name Server Cache Daemon (NSCD).
  3. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
  4. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
  5. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
  6. You must create a Grid Management Repository database.
Correct answer: ADE
Question 9
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
  1. an O/S user to own the Oracle Database installation
  2. an O/S group called dba
  3. an O/S user to own the Grid Infrastructure installation
  4. an O/S group to own the software inventory
  5. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
  6. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
Correct answer: CD
Question 10
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)
  1. Create the CURRENT_YR directory in the root directory (+).
  2. Create the CURRENT_YR directory in the +DATA disk group.
  3. Add the DATAFILE ‘+DATA/CURRENT_YR/sales.dbf’ clause to the command.
  4. Add the AUTOEXTEND ON clause to the command.
  5. Add the DATAFILE ‘/CURRENT_YR/sales.dbf’ clause to the command.
Correct answer: BC
Question 11
Examine this query and output:
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)
  1. exec sys.dbms_shared_pool.keep(‘SEQ1’,’Q’)
  2. alter sequence seq1 cache 10000;
  3. alter sequence seq1 noorder;
  4. alter sequence seq1 keep;
  5. alter sequence seq1 order;
Correct answer: BC
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!